[hibernate - jpa] @CollectionOfElements without create the apposite table

Posted by blow on Stack Overflow See other posts from Stack Overflow or by blow
Published on 2010-06-02T20:13:13Z Indexed on 2010/06/02 21:14 UTC
Read the original article Hit count: 348

Filed under:
|
|
|

Hi all.

I have this:

Municipality class

@Entity
public class Municipality implements Serializable {

@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Long id;
private String country;
private String province;
private String name;
@Column(name="cod_catasto")
private String codCatastale;
private String cap;
@CollectionOfElements
private List<Address> addressList;


public Municipality() {
}

...

Address class

@Embeddable
public class Address implements Serializable {

@ManyToOne(fetch=FetchType.LAZY)
@Cascade(CascadeType.SAVE_UPDATE)
private Municipality municipality;
@Column(length=45)
private String address;

public Address() {
}

...

Address is embedded in another class Person.

When i save an instance of Person, hibernate create 3 tables: PERSON, MUNICIPALITY and MUNICIPALITY_ADDRESSLIST.

MUNICIPALITY_ADDRESSLIST contains 2 fields: MUNICIPALITY_ID (FK) and STREET. I don't want this table, i only want the ID of table MUNICIPALITY into table PERSON(that embeds Address), what should i do?

I tried to add @JoinTable in Municipality entity like this:

@CollectionOfElements
@JoinTable(name="person")
private List<Address> addressList;

It partially worked, but i cant choose the column name of table PERSON that contains ID of the table MUNICIPALITY, it is, by hibernate choose, simply "MUNICIPALITY_ID"...

Thbaks.

© Stack Overflow or respective owner

Related posts about java

Related posts about hibernate